Demystifying Data
06 - Data Visualisation
Mick Cooney mcooney@describedata.com
2022-10-13
Purpose
Tell A Story
Total Exposure of MTPL Data by Region
| Region | Total Exposure |
|---|---|
| Centre | 102712.90 |
| Ile-de-France | 30208.64 |
| Provence-Alpes-Cotes-D’Azur | 35790.32 |
| Rhone-Alpes | 45347.42 |
| Other | 144440.16 |
Total Exposure of MTPL Data by Region
| Region | Total Exposure |
|---|---|
| Centre | 102,712.90 |
| Ile-de-France | 30,208.64 |
| Provence-Alpes-Cotes-D’Azur | 35,790.32 |
| Rhone-Alpes | 45,347.42 |
| Other | 144,440.16 |
Chart Types
Line plots
Scatter plots
Histograms
Error lines
French Motor Third-Party Liability
CASdatasets
Policy
| IDpol | ClaimNb | Exposure | VehPower | VehAge | DrivAge | BonusMalus | VehBrand | VehGas | Area | Density | Region |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 0.10 | 5 | 0 | 55 | 50 | B12 | Regular | D | 1217 | Rhone-Alpes |
| 3 | 1 | 0.77 | 5 | 0 | 55 | 50 | B12 | Regular | D | 1217 | Rhone-Alpes |
| 5 | 1 | 0.75 | 6 | 2 | 52 | 50 | B12 | Diesel | B | 54 | Picardie |
| 10 | 1 | 0.09 | 7 | 0 | 46 | 50 | B12 | Diesel | B | 76 | Aquitaine |
| 11 | 1 | 0.84 | 7 | 0 | 46 | 50 | B12 | Diesel | B | 76 | Aquitaine |
Claims
| IDpol | ClaimAmount |
|---|---|
| 1552 | 995.20 |
| 1010996 | 1128.12 |
| 4024277 | 1851.11 |
| 4007252 | 1204.00 |
| 4046424 | 1204.00 |
678,013 Policy Rows
26,639 Claim Rows
Visualisation and Exploration
Claim Rates
Geospatial Data
Visualise Comparisons
Compare Region by Fuel Type
Compare Region by Vehicle Brand
Pie Charts
Exposure by Region
| Region | Total Exposure |
|---|---|
| Alsace | 1,209.12 |
| Aquitaine | 14,322.17 |
| Auvergne | 2,322.88 |
| Basse-Normandie | 6,657.90 |
| Bourgogne | 5,025.36 |
| Bretagne | 27,753.46 |
| Centre | 102,712.90 |
| Champagne-Ardenne | 1,205.83 |
| Corse | 1,765.94 |
| Franche-Comte | 564.01 |
| Haute-Normandie | 3,177.68 |
| Ile-de-France | 30,208.64 |
| Languedoc-Roussillon | 14,736.10 |
| Limousin | 2,395.99 |
| Midi-Pyrenees | 7,020.11 |
| Nord-Pas-de-Calais | 19,611.75 |
| Pays-de-la-Loire | 21,934.03 |
| Picardie | 3,574.41 |
| Poitou-Charentes | 11,163.41 |
| Provence-Alpes-Cotes-D’Azur | 35,790.32 |
| Rhone-Alpes | 45,347.42 |
Aggregate Under 10%
Aggregate Under 5%
Summary
Book Suggestions
Thank You